Letter abbreviations:
- <int> stands for integers.
- <dbl> stands for real numbers.
- <chr> stands for character vectors.
- <dttm> stands for date-times.

View(nycflights13::flights)

5.2.4 Exercises

1a.

filter(flights,arr_delay >= 120)

1b.

filter(flights,dest %in% c("IAH","HOU"))

1c.

filter(flights, carrier %in% c("AA","DL","UA"))

1d.

filter(flights, month %in% 7:9)

1e.

filter(flights, arr_delay > 120, dep_delay <= 0)

1f.

filter(flights, dep_delay >= 60, (dep_delay - arr_delay > 30))

1g.

filter(flights, dep_time >= 2400 | dep_time <= 600)
  1. <between> is a shortcut for a<=x<=b.
filter(flights, between(dep_time, 600 ,2400))
sum(is.na(flights$dep_time))
[1] 8255
map_dbl(flights, ~ sum(is.na(.x)))
          year          month 
             0              0 
           day       dep_time 
             0           8255 
sched_dep_time      dep_delay 
             0           8255 
      arr_time sched_arr_time 
          8713              0 
     arr_delay        carrier 
          9430              0 
        flight        tailnum 
             0           2512 
        origin           dest 
             0              0 
      air_time       distance 
          9430              0 
          hour         minute 
             0              0 
     time_hour 
             0 

Airtime, arr_delay, dep_delay and tail number have missing values.

  1. Unsure

5.3.1 Exercises

  1. Unsure
arrange(flights, dep_delay)
arrange(flights, desc(dep_delay))
arrange(flights, air_time)
# Shortest
flights %>%
  arrange(air_time) %>%
  select(flight, air_time)
# Fastest
flights %>%
  arrange(-air_time) %>%
  select(flight, air_time)

5.4.1 Exercises

select(flights, dep_time, dep_delay, arr_time, arr_delay)
select(flights, starts_with("dep"), starts_with("arr"))
select_(flights, "dep_time", "dep_delay", "arr_time", "arr_delay")
select(flights, arr_delay,arr_delay)

Nothing, only returns once.

vars <- c("year", "month", "day", "dep_delay", "arr_delay")
select(flights, one_of(vars))

Unsure why helpful.

select(flights, contains("TIME"))

Unsure.

LS0tCnRpdGxlOiAiRGF0YSBUcmFuc2Zvcm1hdGlvbiIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUpCmxpYnJhcnkobnljZmxpZ2h0czEzKQpsaWJyYXJ5KHRpZHl2ZXJzZSkKYGBgCgpMZXR0ZXIgYWJicmV2aWF0aW9uczogIAotIGA8aW50PmAgc3RhbmRzIGZvciBpbnRlZ2Vycy4gIAotIGA8ZGJsPmAgc3RhbmRzIGZvciByZWFsIG51bWJlcnMuICAKLSBgPGNocj5gIHN0YW5kcyBmb3IgY2hhcmFjdGVyIHZlY3RvcnMuICAKLSBgPGR0dG0+YCBzdGFuZHMgZm9yIGRhdGUtdGltZXMuICAKCmBgYHtyfQpWaWV3KG55Y2ZsaWdodHMxMzo6ZmxpZ2h0cykKYGBgCgojIyMgNS4yLjQgRXhlcmNpc2VzCgoxYS4gIApgYGB7cn0KZmlsdGVyKGZsaWdodHMsYXJyX2RlbGF5ID49IDEyMCkKYGBgCgoxYi4KYGBge3J9CmZpbHRlcihmbGlnaHRzLGRlc3QgJWluJSBjKCJJQUgiLCJIT1UiKSkKCmBgYAoKMWMuCmBgYHtyfQpmaWx0ZXIoZmxpZ2h0cywgY2FycmllciAlaW4lIGMoIkFBIiwiREwiLCJVQSIpKQpgYGAKCjFkLgpgYGB7cn0KZmlsdGVyKGZsaWdodHMsIG1vbnRoICVpbiUgNzo5KQpgYGAKCjFlLgoKYGBge3J9CmZpbHRlcihmbGlnaHRzLCBhcnJfZGVsYXkgPiAxMjAsIGRlcF9kZWxheSA8PSAwKQpgYGAKCjFmLgoKYGBge3J9CmZpbHRlcihmbGlnaHRzLCBkZXBfZGVsYXkgPj0gNjAsIChkZXBfZGVsYXkgLSBhcnJfZGVsYXkgPiAzMCkpCmBgYAoKMWcuCmBgYHtyfQpmaWx0ZXIoZmxpZ2h0cywgZGVwX3RpbWUgPj0gMjQwMCB8IGRlcF90aW1lIDw9IDYwMCkKYGBgCgoyLiBgPGJldHdlZW4+YCBpcyBhIHNob3J0Y3V0IGZvciBhPD14PD1iLgoKYGBge3J9CmZpbHRlcihmbGlnaHRzLCBiZXR3ZWVuKGRlcF90aW1lLCA2MDAgLDI0MDApKQpgYGAKCjMuCmBgYHtyfQpzdW0oaXMubmEoZmxpZ2h0cyRkZXBfdGltZSkpCm1hcF9kYmwoZmxpZ2h0cywgfiBzdW0oaXMubmEoLngpKSkKYGBgCgogQWlydGltZSwgYXJyX2RlbGF5LCBkZXBfZGVsYXkgYW5kIHRhaWwgbnVtYmVyIGhhdmUgbWlzc2luZyB2YWx1ZXMuCiAKIDQuIAogVW5zdXJlCiAKIAojIyMjNS4zLjEgRXhlcmNpc2VzCgoxLiBVbnN1cmUgIAoyLiAKCmBgYHtyfQphcnJhbmdlKGZsaWdodHMsIGRlcF9kZWxheSkKYXJyYW5nZShmbGlnaHRzLCBkZXNjKGRlcF9kZWxheSkpCmBgYAozLgpgYGB7cn0KYXJyYW5nZShmbGlnaHRzLCBhaXJfdGltZSkKYGBgCgoKNC4KYGBge3J9CiMgU2hvcnRlc3QKZmxpZ2h0cyAlPiUKICBhcnJhbmdlKGFpcl90aW1lKSAlPiUKICBzZWxlY3QoZmxpZ2h0LCBhaXJfdGltZSkKIyBGYXN0ZXN0CmZsaWdodHMgJT4lCiAgYXJyYW5nZSgtYWlyX3RpbWUpICU+JQogIHNlbGVjdChmbGlnaHQsIGFpcl90aW1lKQpgYGAKCiMjIyM1LjQuMSBFeGVyY2lzZXMKCjEuIApgYGB7cn0Kc2VsZWN0KGZsaWdodHMsIGRlcF90aW1lLCBkZXBfZGVsYXksIGFycl90aW1lLCBhcnJfZGVsYXkpCnNlbGVjdChmbGlnaHRzLCBzdGFydHNfd2l0aCgiZGVwIiksIHN0YXJ0c193aXRoKCJhcnIiKSkKc2VsZWN0XyhmbGlnaHRzLCAiZGVwX3RpbWUiLCAiZGVwX2RlbGF5IiwgImFycl90aW1lIiwgImFycl9kZWxheSIpCmBgYAoKMi4KYGBge3J9CnNlbGVjdChmbGlnaHRzLCBhcnJfZGVsYXksYXJyX2RlbGF5KQpgYGAKCk5vdGhpbmcsIG9ubHkgcmV0dXJucyBvbmNlLgoKMy4KCmBgYHtyfQp2YXJzIDwtIGMoInllYXIiLCAibW9udGgiLCAiZGF5IiwgImRlcF9kZWxheSIsICJhcnJfZGVsYXkiKQpzZWxlY3QoZmxpZ2h0cywgb25lX29mKHZhcnMpKQpgYGAKVW5zdXJlIHdoeSBoZWxwZnVsLgoKNC4KCmBgYHtyfQoKc2VsZWN0KGZsaWdodHMsIGNvbnRhaW5zKCJUSU1FIikpCmBgYAoKVW5zdXJlLgoKCgoKCgoKCgoKCgoKCgo=